package kr.hkit.powerjava.chapter26;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Properties;
import java.util.Scanner;

import kr.hkit.powerjava.chapter26.common.ConnectionFactory;
import kr.hkit.powerjava.chapter26.dao.DepartmentDAO;
import kr.hkit.powerjava.chapter26.dto.Department;
import kr.hkit.powerjava.chapter26.dto.Employee;
import kr.hkit.powerjava.chapter26.service.AbsService;
import kr.hkit.powerjava.chapter26.service.DepartmentService;
import kr.hkit.powerjava.chapter26.service.EmployeeService;

public class TestMain {
	public static void main(String[] args) {
		Scanner sc= new Scanner(System.in);
		Connection connection= ConnectionFactory.getConnection();

		/*AbsService<Department> deptSvc = new DepartmentService(sc, connection);
		deptSvc.prnMenu();*/
		AbsService<Employee> empSvc = new EmployeeService(sc, connection);
		empSvc.prnMenu();
				
				
		/*String driver= "com.mysql.jdbc.Driver";
		String url="jdbc:mysql://localhost:3306/mysql_study";
		String user="root";
		String password="1111";
		DBProperties.savePropertis("dbcon.xml", driver,url,user,password);
		Properties prop=DBProperties.loProperties("dbcon.xml");
		System.out.println(prop.getProperty("DRIVER"));
		System.out.println(prop.getProperty("URL"));
		System.out.println(prop.getProperty("USER"));
		System.out.println(prop.getProperty("PASSWORD"));
		-------------------------------------------------
		Connection con=ConnectionFactory.getConnection();
		System.out.println(con);*/
	/*DepartmentDAO dao=new DepartmentDAO();
	try {
		ArrayList<Department> list= dao.listItems();
		for(Department d:list){
			System.out.println(d);
		}
	} catch (SQLException e1) {
		e1.printStackTrace();
	}
	Department d= new Department(6, "마케팅", 8);
	try {
		dao.insertItem(d);
		System.out.println("삽입 성공"+d);
	} catch (SQLException e) {
		System.err.println(e.getMessage()+":"+e.getErrorCode());
	}
	try {
		d.setDeptname("교육");
		dao.updateItemByNo(d);
		System.out.println("갱신 성공"+d);
	} catch (Exception e) {
		// TODO: handle exception
	}
	try {
		dao.deleteItemByNo(new Department(6));
		System.out.println("삭제 성공");
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}*/
	}
	
}
